create proc dbo.SelectWareInforByID
@id int
as
select wareinfo  from wareDetails where id=@id